DateAdd(datepart, number, date)


Returns a date to which a specified time interval has been added.

See also DateConvert, DatePart, and CreateTimeSpan.

datepart

One of the following strings:

• yyyy -- Year
• q -- Quarter
• m -- Month
• y -- Day of year
• d -- Day
• w -- Weekday
• ww -- Week
• h -- Hour
• n -- Minute
• s -- Second

number

Number of units of datepart to add to date (positive to get dates in the future or negative to get dates in the past).

date

Date/time object in the period from 100 AD to 9999 AD.